Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 580322 |
| Missing cells | 2848663 |
| Missing cells (%) | 15.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 137.3 MiB |
| Average record size in memory | 248.0 B |
Variable types
| Numeric | 20 |
|---|---|
| DateTime | 1 |
| Categorical | 4 |
| Text | 6 |
CANCELLED is highly imbalanced (90.1%) | Imbalance |
DIVERTED is highly imbalanced (97.6%) | Imbalance |
DEP_TIME has 7150 (1.2%) missing values | Missing |
DEP_DELAY has 7152 (1.2%) missing values | Missing |
TAXI_OUT has 7319 (1.3%) missing values | Missing |
TAXI_IN has 7579 (1.3%) missing values | Missing |
ARR_TIME has 7579 (1.3%) missing values | Missing |
ARR_DELAY has 8789 (1.5%) missing values | Missing |
CANCELLATION_CODE has 572916 (98.7%) missing values | Missing |
AIR_TIME has 8789 (1.5%) missing values | Missing |
CARRIER_DELAY has 444278 (76.6%) missing values | Missing |
WEATHER_DELAY has 444278 (76.6%) missing values | Missing |
NAS_DELAY has 444278 (76.6%) missing values | Missing |
SECURITY_DELAY has 444278 (76.6%) missing values | Missing |
LATE_AIRCRAFT_DELAY has 444278 (76.6%) missing values | Missing |
WEATHER_DELAY is highly skewed (γ1 = 22.8175781) | Skewed |
SECURITY_DELAY is highly skewed (γ1 = 54.90941663) | Skewed |
DEP_DELAY has 26867 (4.6%) zeros | Zeros |
ARR_DELAY has 11025 (1.9%) zeros | Zeros |
CARRIER_DELAY has 61079 (10.5%) zeros | Zeros |
WEATHER_DELAY has 129948 (22.4%) zeros | Zeros |
NAS_DELAY has 66192 (11.4%) zeros | Zeros |
SECURITY_DELAY has 135274 (23.3%) zeros | Zeros |
LATE_AIRCRAFT_DELAY has 67326 (11.6%) zeros | Zeros |
Reproduction
| Analysis started | 2024-03-30 06:21:13.634467 |
|---|---|
| Analysis finished | 2024-03-30 06:24:51.993935 |
| Duration | 3 minutes and 38.36 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
DAY_OF_WEEK
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.977926 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.9153291 |
|---|---|
| Coefficient of variation (CV) | 0.48148937 |
| Kurtosis | -1.1007519 |
| Mean | 3.977926 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.0091388446 |
| Sum | 2308478 |
| Variance | 3.6684856 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 5 | 97407 | |
| 4 | 97144 | |
| 3 | 92208 | |
| 1 | 77761 | |
| 7 | 75302 | |
| 2 | 72908 | |
| 6 | 67592 |
| Value | Count | Frequency (%) |
| 1 | 77761 | |
| 2 | 72908 | |
| 3 | 92208 | |
| 4 | 97144 | |
| 5 | 97407 | |
| 6 | 67592 | |
| 7 | 75302 |
| Value | Count | Frequency (%) |
| 7 | 75302 | |
| 6 | 67592 | |
| 5 | 97407 | |
| 4 | 97144 | |
| 3 | 92208 | |
| 2 | 72908 | |
| 1 | 77761 |
FL_DATE
Date
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
| Minimum | 2023-03-01 00:00:00 |
|---|---|
| Maximum | 2023-03-31 00:00:00 |
Histogram with fixed size bins (bins=31)
OP_UNIQUE_CARRIER
Categorical
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
| WN | |
|---|---|
| DL | |
| AA | |
| UA | |
| OO | |
| Other values (10) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1160644 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 9E |
|---|---|
| 2nd row | 9E |
| 3rd row | 9E |
| 4th row | 9E |
| 5th row | 9E |
Common Values
| Value | Count | Frequency (%) |
| WN | 117997 | |
| DL | 82791 | |
| AA | 78705 | |
| UA | 61590 | |
| OO | 57835 | |
| YX | 27886 | 4.8% |
| B6 | 25793 | 4.4% |
| NK | 22613 | 3.9% |
| AS | 19975 | 3.4% |
| MQ | 19380 | 3.3% |
| Other values (5) | 65757 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| wn | 117997 | |
| dl | 82791 | |
| aa | 78705 | |
| ua | 61590 | |
| oo | 57835 | |
| yx | 27886 | 4.8% |
| b6 | 25793 | 4.4% |
| nk | 22613 | 3.9% |
| as | 19975 | 3.4% |
| mq | 19380 | 3.3% |
| Other values (5) | 65757 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 245789 | |
| N | 140610 | |
| O | 132141 | |
| W | 117997 | |
| D | 82791 | 7.1% |
| L | 82791 | 7.1% |
| U | 61590 | 5.3% |
| 9 | 31402 | 2.7% |
| Y | 27886 | 2.4% |
| X | 27886 | 2.4% |
| Other values (11) | 209761 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1160644 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 245789 | |
| N | 140610 | |
| O | 132141 | |
| W | 117997 | |
| D | 82791 | 7.1% |
| L | 82791 | 7.1% |
| U | 61590 | 5.3% |
| 9 | 31402 | 2.7% |
| Y | 27886 | 2.4% |
| X | 27886 | 2.4% |
| Other values (11) | 209761 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1160644 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 245789 | |
| N | 140610 | |
| O | 132141 | |
| W | 117997 | |
| D | 82791 | 7.1% |
| L | 82791 | 7.1% |
| U | 61590 | 5.3% |
| 9 | 31402 | 2.7% |
| Y | 27886 | 2.4% |
| X | 27886 | 2.4% |
| Other values (11) | 209761 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1160644 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 245789 | |
| N | 140610 | |
| O | 132141 | |
| W | 117997 | |
| D | 82791 | 7.1% |
| L | 82791 | 7.1% |
| U | 61590 | 5.3% |
| 9 | 31402 | 2.7% |
| Y | 27886 | 2.4% |
| X | 27886 | 2.4% |
| Other values (11) | 209761 |
OP_CARRIER_FL_NUM
Real number (ℝ)
| Distinct | 5860 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2261.6067 |
| Minimum | 1 |
|---|---|
| Maximum | 8819 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 265 |
| Q1 | 1010 |
| median | 2017 |
| Q3 | 3282 |
| 95-th percentile | 5334 |
| Maximum | 8819 |
| Range | 8818 |
| Interquartile range (IQR) | 2272 |
Descriptive statistics
| Standard deviation | 1559.435 |
|---|---|
| Coefficient of variation (CV) | 0.68952527 |
| Kurtosis | -0.5414145 |
| Mean | 2261.6067 |
| Median Absolute Deviation (MAD) | 1080 |
| Skewness | 0.63613163 |
| Sum | 1.3124601 × 109 |
| Variance | 2431837.4 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 517 | 319 | 0.1% |
| 334 | 311 | 0.1% |
| 321 | 307 | 0.1% |
| 1103 | 291 | 0.1% |
| 1633 | 291 | 0.1% |
| 680 | 290 | < 0.1% |
| 522 | 288 | < 0.1% |
| 2086 | 286 | < 0.1% |
| 1378 | 285 | < 0.1% |
| 1318 | 285 | < 0.1% |
| Other values (5850) | 577369 |
| Value | Count | Frequency (%) |
| 1 | 144 | |
| 2 | 185 | |
| 3 | 192 | |
| 4 | 179 | |
| 5 | 94 | |
| 6 | 98 | |
| 7 | 114 | |
| 8 | 109 | |
| 9 | 179 | |
| 10 | 208 |
| Value | Count | Frequency (%) |
| 8819 | 1 | < 0.1% |
| 8801 | 1 | < 0.1% |
| 8792 | 1 | < 0.1% |
| 8791 | 1 | < 0.1% |
| 8790 | 2 | |
| 8789 | 1 | < 0.1% |
| 8788 | 4 | |
| 8787 | 1 | < 0.1% |
| 8786 | 1 | < 0.1% |
| 8785 | 1 | < 0.1% |
ORIGIN_AIRPORT_ID
Real number (ℝ)
| Distinct | 338 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12650.406 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14027 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2735 |
Descriptive statistics
| Standard deviation | 1525.4316 |
|---|---|
| Coefficient of variation (CV) | 0.12058361 |
| Kurtosis | -1.2897586 |
| Mean | 12650.406 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.10792407 |
| Sum | 7.3413087 × 109 |
| Variance | 2326941.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10397 | 28350 | 4.9% |
| 11292 | 23694 | 4.1% |
| 11298 | 22583 | 3.9% |
| 13930 | 21905 | 3.8% |
| 11057 | 16457 | 2.8% |
| 12892 | 15910 | 2.7% |
| 12889 | 15890 | 2.7% |
| 14107 | 15557 | 2.7% |
| 12953 | 14763 | 2.5% |
| 13204 | 14593 | 2.5% |
| Other values (328) | 390620 |
| Value | Count | Frequency (%) |
| 10135 | 392 | 0.1% |
| 10136 | 84 | < 0.1% |
| 10140 | 1704 | |
| 10141 | 62 | < 0.1% |
| 10146 | 89 | < 0.1% |
| 10155 | 84 | < 0.1% |
| 10157 | 149 | < 0.1% |
| 10158 | 248 | < 0.1% |
| 10165 | 9 | < 0.1% |
| 10170 | 58 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 147 | < 0.1% |
| 16218 | 124 | < 0.1% |
| 15991 | 62 | < 0.1% |
| 15919 | 943 | |
| 15841 | 62 | < 0.1% |
| 15624 | 699 | |
| 15607 | 92 | < 0.1% |
| 15582 | 54 | < 0.1% |
| 15569 | 54 | < 0.1% |
| 15412 | 1125 |
ORIGIN
Text
| Distinct | 338 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1740966 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LGA |
|---|---|
| 2nd row | DTW |
| 3rd row | GRB |
| 4th row | ATL |
| 5th row | FAY |
| Value | Count | Frequency (%) |
| atl | 28350 | 4.9% |
| den | 23694 | 4.1% |
| dfw | 22583 | 3.9% |
| ord | 21905 | 3.8% |
| clt | 16457 | 2.8% |
| lax | 15910 | 2.7% |
| las | 15890 | 2.7% |
| phx | 15557 | 2.7% |
| lga | 14763 | 2.5% |
| mco | 14593 | 2.5% |
| Other values (328) | 390620 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 197706 | 11.4% |
| L | 161157 | 9.3% |
| S | 148393 | 8.5% |
| D | 134795 | 7.7% |
| T | 92346 | 5.3% |
| O | 89007 | 5.1% |
| C | 88035 | 5.1% |
| M | 77487 | 4.5% |
| F | 71488 | 4.1% |
| P | 67712 | 3.9% |
| Other values (16) | 612840 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1740966 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 197706 | 11.4% |
| L | 161157 | 9.3% |
| S | 148393 | 8.5% |
| D | 134795 | 7.7% |
| T | 92346 | 5.3% |
| O | 89007 | 5.1% |
| C | 88035 | 5.1% |
| M | 77487 | 4.5% |
| F | 71488 | 4.1% |
| P | 67712 | 3.9% |
| Other values (16) | 612840 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1740966 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 197706 | 11.4% |
| L | 161157 | 9.3% |
| S | 148393 | 8.5% |
| D | 134795 | 7.7% |
| T | 92346 | 5.3% |
| O | 89007 | 5.1% |
| C | 88035 | 5.1% |
| M | 77487 | 4.5% |
| F | 71488 | 4.1% |
| P | 67712 | 3.9% |
| Other values (16) | 612840 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1740966 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 197706 | 11.4% |
| L | 161157 | 9.3% |
| S | 148393 | 8.5% |
| D | 134795 | 7.7% |
| T | 92346 | 5.3% |
| O | 89007 | 5.1% |
| C | 88035 | 5.1% |
| M | 77487 | 4.5% |
| F | 71488 | 4.1% |
| P | 67712 | 3.9% |
| Other values (16) | 612840 |
ORIGIN_CITY_NAME
Text
| Distinct | 332 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.03145 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7562437 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York, NY |
|---|---|
| 2nd row | Detroit, MI |
| 3rd row | Green Bay, WI |
| 4th row | Atlanta, GA |
| 5th row | Fayetteville, NC |
| Value | Count | Frequency (%) |
| ca | 60865 | 4.5% |
| tx | 58449 | 4.3% |
| fl | 56562 | 4.2% |
| ny | 33978 | 2.5% |
| new | 31368 | 2.3% |
| ga | 30547 | 2.3% |
| il | 30167 | 2.2% |
| san | 29060 | 2.1% |
| chicago | 28976 | 2.1% |
| atlanta | 28350 | 2.1% |
| Other values (403) | 966125 |
Most occurring characters
| Value | Count | Frequency (%) |
| 774125 | 10.2% | |
| , | 580322 | 7.7% |
| a | 576157 | 7.6% |
| o | 416846 | 5.5% |
| e | 400611 | 5.3% |
| n | 370287 | 4.9% |
| t | 358811 | 4.7% |
| l | 326780 | 4.3% |
| i | 284236 | 3.8% |
| r | 276401 | 3.7% |
| Other values (46) | 3197861 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7562437 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 774125 | 10.2% | |
| , | 580322 | 7.7% |
| a | 576157 | 7.6% |
| o | 416846 | 5.5% |
| e | 400611 | 5.3% |
| n | 370287 | 4.9% |
| t | 358811 | 4.7% |
| l | 326780 | 4.3% |
| i | 284236 | 3.8% |
| r | 276401 | 3.7% |
| Other values (46) | 3197861 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7562437 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 774125 | 10.2% | |
| , | 580322 | 7.7% |
| a | 576157 | 7.6% |
| o | 416846 | 5.5% |
| e | 400611 | 5.3% |
| n | 370287 | 4.9% |
| t | 358811 | 4.7% |
| l | 326780 | 4.3% |
| i | 284236 | 3.8% |
| r | 276401 | 3.7% |
| Other values (46) | 3197861 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7562437 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 774125 | 10.2% | |
| , | 580322 | 7.7% |
| a | 576157 | 7.6% |
| o | 416846 | 5.5% |
| e | 400611 | 5.3% |
| n | 370287 | 4.9% |
| t | 358811 | 4.7% |
| l | 326780 | 4.3% |
| i | 284236 | 3.8% |
| r | 276401 | 3.7% |
| Other values (46) | 3197861 |
ORIGIN_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.1463205 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4727489 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York |
|---|---|
| 2nd row | Michigan |
| 3rd row | Wisconsin |
| 4th row | Georgia |
| 5th row | North Carolina |
| Value | Count | Frequency (%) |
| california | 60865 | 9.1% |
| texas | 58449 | 8.8% |
| florida | 56562 | 8.5% |
| new | 49475 | 7.4% |
| york | 33978 | 5.1% |
| georgia | 30547 | 4.6% |
| illinois | 30167 | 4.5% |
| carolina | 28628 | 4.3% |
| colorado | 27600 | 4.1% |
| north | 25302 | 3.8% |
| Other values (51) | 265511 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 629408 | |
| i | 532018 | 11.3% |
| o | 457105 | 9.7% |
| r | 348102 | 7.4% |
| n | 342829 | 7.3% |
| e | 289987 | 6.1% |
| s | 265632 | 5.6% |
| l | 263525 | 5.6% |
| d | 119717 | 2.5% |
| C | 119187 | 2.5% |
| Other values (37) | 1359979 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4727489 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 629408 | |
| i | 532018 | 11.3% |
| o | 457105 | 9.7% |
| r | 348102 | 7.4% |
| n | 342829 | 7.3% |
| e | 289987 | 6.1% |
| s | 265632 | 5.6% |
| l | 263525 | 5.6% |
| d | 119717 | 2.5% |
| C | 119187 | 2.5% |
| Other values (37) | 1359979 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4727489 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 629408 | |
| i | 532018 | 11.3% |
| o | 457105 | 9.7% |
| r | 348102 | 7.4% |
| n | 342829 | 7.3% |
| e | 289987 | 6.1% |
| s | 265632 | 5.6% |
| l | 263525 | 5.6% |
| d | 119717 | 2.5% |
| C | 119187 | 2.5% |
| Other values (37) | 1359979 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4727489 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 629408 | |
| i | 532018 | 11.3% |
| o | 457105 | 9.7% |
| r | 348102 | 7.4% |
| n | 342829 | 7.3% |
| e | 289987 | 6.1% |
| s | 265632 | 5.6% |
| l | 263525 | 5.6% |
| d | 119717 | 2.5% |
| C | 119187 | 2.5% |
| Other values (37) | 1359979 |
ORIGIN_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.013518 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 33 |
| median | 44 |
| Q3 | 81 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.75784 |
|---|---|
| Coefficient of variation (CV) | 0.49539153 |
| Kurtosis | -1.3253331 |
| Mean | 54.013518 |
| Median Absolute Deviation (MAD) | 22 |
| Skewness | 0.0068371993 |
| Sum | 31345233 |
| Variance | 715.98198 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 91 | 60865 | 10.5% |
| 74 | 58449 | 10.1% |
| 33 | 56562 | 9.7% |
| 22 | 33978 | 5.9% |
| 34 | 30547 | 5.3% |
| 41 | 30167 | 5.2% |
| 82 | 27600 | 4.8% |
| 36 | 23842 | 4.1% |
| 38 | 20314 | 3.5% |
| 81 | 18061 | 3.1% |
| Other values (42) | 219937 |
| Value | Count | Frequency (%) |
| 1 | 2730 | 0.5% |
| 2 | 11396 | |
| 3 | 2906 | 0.5% |
| 4 | 609 | 0.1% |
| 5 | 103 | < 0.1% |
| 11 | 2094 | 0.4% |
| 12 | 1001 | 0.2% |
| 13 | 12490 | |
| 14 | 548 | 0.1% |
| 15 | 1262 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 14849 | 2.6% |
| 92 | 6313 | 1.1% |
| 91 | 60865 | |
| 88 | 1039 | 0.2% |
| 87 | 9873 | 1.7% |
| 86 | 1921 | 0.3% |
| 85 | 17534 | 3.0% |
| 84 | 2106 | 0.4% |
| 83 | 2374 | 0.4% |
| 82 | 27600 |
DEST_AIRPORT_ID
Real number (ℝ)
| Distinct | 338 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12650.369 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14027 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2735 |
Descriptive statistics
| Standard deviation | 1525.3828 |
|---|---|
| Coefficient of variation (CV) | 0.1205801 |
| Kurtosis | -1.2897138 |
| Mean | 12650.369 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.1080226 |
| Sum | 7.3412873 × 109 |
| Variance | 2326792.6 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10397 | 28339 | 4.9% |
| 11292 | 23699 | 4.1% |
| 11298 | 22582 | 3.9% |
| 13930 | 21909 | 3.8% |
| 11057 | 16451 | 2.8% |
| 12892 | 15913 | 2.7% |
| 12889 | 15895 | 2.7% |
| 14107 | 15546 | 2.7% |
| 12953 | 14764 | 2.5% |
| 13204 | 14593 | 2.5% |
| Other values (328) | 390631 |
| Value | Count | Frequency (%) |
| 10135 | 392 | 0.1% |
| 10136 | 84 | < 0.1% |
| 10140 | 1702 | |
| 10141 | 62 | < 0.1% |
| 10146 | 89 | < 0.1% |
| 10155 | 84 | < 0.1% |
| 10157 | 148 | < 0.1% |
| 10158 | 248 | < 0.1% |
| 10165 | 9 | < 0.1% |
| 10170 | 58 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 146 | < 0.1% |
| 16218 | 124 | < 0.1% |
| 15991 | 62 | < 0.1% |
| 15919 | 944 | |
| 15841 | 62 | < 0.1% |
| 15624 | 701 | |
| 15607 | 92 | < 0.1% |
| 15582 | 56 | < 0.1% |
| 15569 | 54 | < 0.1% |
| 15412 | 1124 |
DEST
Text
| Distinct | 338 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1740966 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BGM |
|---|---|
| 2nd row | GRB |
| 3rd row | DTW |
| 4th row | FAY |
| 5th row | ATL |
| Value | Count | Frequency (%) |
| atl | 28339 | 4.9% |
| den | 23699 | 4.1% |
| dfw | 22582 | 3.9% |
| ord | 21909 | 3.8% |
| clt | 16451 | 2.8% |
| lax | 15913 | 2.7% |
| las | 15895 | 2.7% |
| phx | 15546 | 2.7% |
| lga | 14764 | 2.5% |
| mco | 14593 | 2.5% |
| Other values (328) | 390631 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 197701 | 11.4% |
| L | 161164 | 9.3% |
| S | 148398 | 8.5% |
| D | 134803 | 7.7% |
| T | 92318 | 5.3% |
| O | 88998 | 5.1% |
| C | 88015 | 5.1% |
| M | 77477 | 4.5% |
| F | 71499 | 4.1% |
| P | 67690 | 3.9% |
| Other values (16) | 612903 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1740966 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 197701 | 11.4% |
| L | 161164 | 9.3% |
| S | 148398 | 8.5% |
| D | 134803 | 7.7% |
| T | 92318 | 5.3% |
| O | 88998 | 5.1% |
| C | 88015 | 5.1% |
| M | 77477 | 4.5% |
| F | 71499 | 4.1% |
| P | 67690 | 3.9% |
| Other values (16) | 612903 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1740966 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 197701 | 11.4% |
| L | 161164 | 9.3% |
| S | 148398 | 8.5% |
| D | 134803 | 7.7% |
| T | 92318 | 5.3% |
| O | 88998 | 5.1% |
| C | 88015 | 5.1% |
| M | 77477 | 4.5% |
| F | 71499 | 4.1% |
| P | 67690 | 3.9% |
| Other values (16) | 612903 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1740966 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 197701 | 11.4% |
| L | 161164 | 9.3% |
| S | 148398 | 8.5% |
| D | 134803 | 7.7% |
| T | 92318 | 5.3% |
| O | 88998 | 5.1% |
| C | 88015 | 5.1% |
| M | 77477 | 4.5% |
| F | 71499 | 4.1% |
| P | 67690 | 3.9% |
| Other values (16) | 612903 |
DEST_CITY_NAME
Text
| Distinct | 332 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.031553 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7562497 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Binghamton, NY |
|---|---|
| 2nd row | Green Bay, WI |
| 3rd row | Detroit, MI |
| 4th row | Fayetteville, NC |
| 5th row | Atlanta, GA |
| Value | Count | Frequency (%) |
| ca | 60848 | 4.5% |
| tx | 58444 | 4.3% |
| fl | 56565 | 4.2% |
| ny | 33991 | 2.5% |
| new | 31374 | 2.3% |
| ga | 30537 | 2.3% |
| il | 30169 | 2.2% |
| san | 29059 | 2.1% |
| chicago | 28977 | 2.1% |
| atlanta | 28339 | 2.1% |
| Other values (403) | 966163 |
Most occurring characters
| Value | Count | Frequency (%) |
| 774144 | 10.2% | |
| , | 580322 | 7.7% |
| a | 576128 | 7.6% |
| o | 416865 | 5.5% |
| e | 400663 | 5.3% |
| n | 370259 | 4.9% |
| t | 358789 | 4.7% |
| l | 326782 | 4.3% |
| i | 284233 | 3.8% |
| r | 276413 | 3.7% |
| Other values (46) | 3197899 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7562497 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 774144 | 10.2% | |
| , | 580322 | 7.7% |
| a | 576128 | 7.6% |
| o | 416865 | 5.5% |
| e | 400663 | 5.3% |
| n | 370259 | 4.9% |
| t | 358789 | 4.7% |
| l | 326782 | 4.3% |
| i | 284233 | 3.8% |
| r | 276413 | 3.7% |
| Other values (46) | 3197899 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7562497 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 774144 | 10.2% | |
| , | 580322 | 7.7% |
| a | 576128 | 7.6% |
| o | 416865 | 5.5% |
| e | 400663 | 5.3% |
| n | 370259 | 4.9% |
| t | 358789 | 4.7% |
| l | 326782 | 4.3% |
| i | 284233 | 3.8% |
| r | 276413 | 3.7% |
| Other values (46) | 3197899 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7562497 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 774144 | 10.2% | |
| , | 580322 | 7.7% |
| a | 576128 | 7.6% |
| o | 416865 | 5.5% |
| e | 400663 | 5.3% |
| n | 370259 | 4.9% |
| t | 358789 | 4.7% |
| l | 326782 | 4.3% |
| i | 284233 | 3.8% |
| r | 276413 | 3.7% |
| Other values (46) | 3197899 |
DEST_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.1462705 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4727460 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York |
|---|---|
| 2nd row | Wisconsin |
| 3rd row | Michigan |
| 4th row | North Carolina |
| 5th row | Georgia |
| Value | Count | Frequency (%) |
| california | 60848 | 9.1% |
| texas | 58444 | 8.8% |
| florida | 56565 | 8.5% |
| new | 49491 | 7.4% |
| york | 33991 | 5.1% |
| georgia | 30537 | 4.6% |
| illinois | 30169 | 4.5% |
| carolina | 28631 | 4.3% |
| colorado | 27602 | 4.1% |
| north | 25297 | 3.8% |
| Other values (51) | 265529 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 629391 | |
| i | 531968 | 11.3% |
| o | 457083 | 9.7% |
| r | 348092 | 7.4% |
| n | 342813 | 7.3% |
| e | 290009 | 6.1% |
| s | 265619 | 5.6% |
| l | 263525 | 5.6% |
| d | 119737 | 2.5% |
| C | 119175 | 2.5% |
| Other values (37) | 1360048 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4727460 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 629391 | |
| i | 531968 | 11.3% |
| o | 457083 | 9.7% |
| r | 348092 | 7.4% |
| n | 342813 | 7.3% |
| e | 290009 | 6.1% |
| s | 265619 | 5.6% |
| l | 263525 | 5.6% |
| d | 119737 | 2.5% |
| C | 119175 | 2.5% |
| Other values (37) | 1360048 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4727460 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 629391 | |
| i | 531968 | 11.3% |
| o | 457083 | 9.7% |
| r | 348092 | 7.4% |
| n | 342813 | 7.3% |
| e | 290009 | 6.1% |
| s | 265619 | 5.6% |
| l | 263525 | 5.6% |
| d | 119737 | 2.5% |
| C | 119175 | 2.5% |
| Other values (37) | 1360048 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4727460 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 629391 | |
| i | 531968 | 11.3% |
| o | 457083 | 9.7% |
| r | 348092 | 7.4% |
| n | 342813 | 7.3% |
| e | 290009 | 6.1% |
| s | 265619 | 5.6% |
| l | 263525 | 5.6% |
| d | 119737 | 2.5% |
| C | 119175 | 2.5% |
| Other values (37) | 1360048 |
DEST_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.009879 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 33 |
| median | 44 |
| Q3 | 81 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.758489 |
|---|---|
| Coefficient of variation (CV) | 0.49543694 |
| Kurtosis | -1.3252958 |
| Mean | 54.009879 |
| Median Absolute Deviation (MAD) | 22 |
| Skewness | 0.0069820568 |
| Sum | 31343121 |
| Variance | 716.01675 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 91 | 60848 | 10.5% |
| 74 | 58444 | 10.1% |
| 33 | 56565 | 9.7% |
| 22 | 33991 | 5.9% |
| 34 | 30537 | 5.3% |
| 41 | 30169 | 5.2% |
| 82 | 27602 | 4.8% |
| 36 | 23839 | 4.1% |
| 38 | 20319 | 3.5% |
| 81 | 18052 | 3.1% |
| Other values (42) | 219956 |
| Value | Count | Frequency (%) |
| 1 | 2729 | 0.5% |
| 2 | 11402 | |
| 3 | 2909 | 0.5% |
| 4 | 611 | 0.1% |
| 5 | 102 | < 0.1% |
| 11 | 2094 | 0.4% |
| 12 | 1001 | 0.2% |
| 13 | 12491 | |
| 14 | 549 | 0.1% |
| 15 | 1263 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 14850 | 2.6% |
| 92 | 6311 | 1.1% |
| 91 | 60848 | |
| 88 | 1038 | 0.2% |
| 87 | 9877 | 1.7% |
| 86 | 1919 | 0.3% |
| 85 | 17539 | 3.0% |
| 84 | 2106 | 0.4% |
| 83 | 2375 | 0.4% |
| 82 | 27602 |
CRS_DEP_TIME
Real number (ℝ)
| Distinct | 1231 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1336.3206 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 600 |
| Q1 | 910 |
| median | 1325 |
| Q3 | 1745 |
| 95-th percentile | 2135 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 835 |
Descriptive statistics
| Standard deviation | 499.12958 |
|---|---|
| Coefficient of variation (CV) | 0.37351036 |
| Kurtosis | -1.0837561 |
| Mean | 1336.3206 |
| Median Absolute Deviation (MAD) | 419 |
| Skewness | 0.074943314 |
| Sum | 7.7549623 × 108 |
| Variance | 249130.34 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 600 | 13752 | 2.4% |
| 700 | 9270 | 1.6% |
| 800 | 5743 | 1.0% |
| 900 | 4231 | 0.7% |
| 730 | 3420 | 0.6% |
| 630 | 3356 | 0.6% |
| 1000 | 3302 | 0.6% |
| 615 | 3233 | 0.6% |
| 1100 | 3053 | 0.5% |
| 1300 | 3034 | 0.5% |
| Other values (1221) | 527928 |
| Value | Count | Frequency (%) |
| 1 | 2 | < 0.1% |
| 2 | 1 | < 0.1% |
| 3 | 3 | < 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 3 | < 0.1% |
| 6 | 4 | < 0.1% |
| 7 | 2 | < 0.1% |
| 9 | 6 | < 0.1% |
| 10 | 15 | |
| 12 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 2359 | 979 | |
| 2357 | 16 | < 0.1% |
| 2356 | 25 | < 0.1% |
| 2355 | 189 | < 0.1% |
| 2354 | 61 | < 0.1% |
| 2353 | 20 | < 0.1% |
| 2352 | 11 | < 0.1% |
| 2351 | 26 | < 0.1% |
| 2350 | 274 | < 0.1% |
| 2349 | 31 | < 0.1% |
DEP_TIME
Real number (ℝ)
MISSING
| Distinct | 1416 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 7150 |
| Missing (%) | 1.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1339.3518 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 557 |
| Q1 | 911 |
| median | 1330 |
| Q3 | 1754 |
| 95-th percentile | 2151 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 843 |
Descriptive statistics
| Standard deviation | 515.20328 |
|---|---|
| Coefficient of variation (CV) | 0.38466613 |
| Kurtosis | -1.0009205 |
| Mean | 1339.3518 |
| Median Absolute Deviation (MAD) | 422 |
| Skewness | 0.019532348 |
| Sum | 7.6767897 × 108 |
| Variance | 265434.42 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 555 | 1698 | 0.3% |
| 556 | 1563 | 0.3% |
| 557 | 1432 | 0.2% |
| 554 | 1431 | 0.2% |
| 558 | 1364 | 0.2% |
| 559 | 1244 | 0.2% |
| 600 | 1207 | 0.2% |
| 553 | 1193 | 0.2% |
| 655 | 1188 | 0.2% |
| 657 | 1076 | 0.2% |
| Other values (1406) | 559776 | |
| (Missing) | 7150 | 1.2% |
| Value | Count | Frequency (%) |
| 1 | 90 | |
| 2 | 65 | |
| 3 | 65 | |
| 4 | 61 | |
| 5 | 67 | |
| 6 | 72 | |
| 7 | 60 | |
| 8 | 57 | |
| 9 | 54 | |
| 10 | 49 |
| Value | Count | Frequency (%) |
| 2400 | 65 | |
| 2359 | 90 | |
| 2358 | 96 | |
| 2357 | 87 | |
| 2356 | 109 | |
| 2355 | 112 | |
| 2354 | 104 | |
| 2353 | 120 | |
| 2352 | 133 | |
| 2351 | 106 |
DEP_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 1150 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 7152 |
| Missing (%) | 1.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.197591 |
| Minimum | -42 |
|---|---|
| Maximum | 4413 |
| Zeros | 26867 |
| Zeros (%) | 4.6% |
| Negative | 313590 |
| Negative (%) | 54.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | -42 |
|---|---|
| 5-th percentile | -10 |
| Q1 | -5 |
| median | -1 |
| Q3 | 12 |
| 95-th percentile | 81 |
| Maximum | 4413 |
| Range | 4455 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 54.542107 |
|---|---|
| Coefficient of variation (CV) | 4.1327321 |
| Kurtosis | 333.49832 |
| Mean | 13.197591 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 12.707971 |
| Sum | 7564463 |
| Variance | 2974.8414 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -5 | 41106 | 7.1% |
| -4 | 38528 | 6.6% |
| -3 | 37803 | 6.5% |
| -2 | 34989 | 6.0% |
| -6 | 32343 | 5.6% |
| -1 | 31178 | 5.4% |
| -7 | 26890 | 4.6% |
| 0 | 26867 | 4.6% |
| -8 | 21105 | 3.6% |
| -9 | 15847 | 2.7% |
| Other values (1140) | 266514 |
| Value | Count | Frequency (%) |
| -42 | 1 | < 0.1% |
| -39 | 1 | < 0.1% |
| -38 | 2 | < 0.1% |
| -37 | 1 | < 0.1% |
| -36 | 2 | < 0.1% |
| -34 | 4 | |
| -33 | 5 | |
| -32 | 1 | < 0.1% |
| -31 | 4 | |
| -30 | 5 |
| Value | Count | Frequency (%) |
| 4413 | 1 | |
| 3249 | 1 | |
| 2810 | 1 | |
| 2681 | 1 | |
| 2552 | 1 | |
| 2368 | 1 | |
| 2255 | 1 | |
| 2111 | 1 | |
| 2019 | 1 | |
| 1996 | 1 |
TAXI_OUT
Real number (ℝ)
MISSING
| Distinct | 167 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 7319 |
| Missing (%) | 1.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.853163 |
| Minimum | 1 |
|---|---|
| Maximum | 201 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 12 |
| median | 15 |
| Q3 | 21 |
| 95-th percentile | 35 |
| Maximum | 201 |
| Range | 200 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 9.6376635 |
|---|---|
| Coefficient of variation (CV) | 0.53982947 |
| Kurtosis | 18.328562 |
| Mean | 17.853163 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 3.058238 |
| Sum | 10229916 |
| Variance | 92.884558 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 12 | 44883 | 7.7% |
| 13 | 44779 | 7.7% |
| 14 | 42638 | 7.3% |
| 11 | 41324 | 7.1% |
| 15 | 38300 | 6.6% |
| 16 | 34385 | 5.9% |
| 10 | 33816 | 5.8% |
| 17 | 29732 | 5.1% |
| 18 | 25862 | 4.5% |
| 9 | 24258 | 4.2% |
| Other values (157) | 213026 |
| Value | Count | Frequency (%) |
| 1 | 18 | < 0.1% |
| 2 | 19 | < 0.1% |
| 3 | 58 | < 0.1% |
| 4 | 182 | < 0.1% |
| 5 | 588 | 0.1% |
| 6 | 2372 | 0.4% |
| 7 | 6882 | 1.2% |
| 8 | 14135 | |
| 9 | 24258 | |
| 10 | 33816 |
| Value | Count | Frequency (%) |
| 201 | 1 | < 0.1% |
| 181 | 1 | < 0.1% |
| 180 | 1 | < 0.1% |
| 169 | 3 | |
| 168 | 1 | < 0.1% |
| 165 | 2 | |
| 163 | 1 | < 0.1% |
| 160 | 1 | < 0.1% |
| 159 | 1 | < 0.1% |
| 158 | 2 |
TAXI_IN
Real number (ℝ)
MISSING
| Distinct | 140 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 7579 |
| Missing (%) | 1.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.954889 |
| Minimum | 1 |
|---|---|
| Maximum | 160 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 18 |
| Maximum | 160 |
| Range | 159 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 6.1259727 |
|---|---|
| Coefficient of variation (CV) | 0.77008903 |
| Kurtosis | 37.578995 |
| Mean | 7.954889 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 4.236224 |
| Sum | 4556107 |
| Variance | 37.527542 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4 | 85122 | |
| 5 | 81039 | |
| 6 | 67578 | |
| 7 | 55528 | |
| 3 | 52369 | |
| 8 | 42693 | |
| 9 | 34109 | 5.9% |
| 10 | 26935 | 4.6% |
| 11 | 20864 | 3.6% |
| 12 | 16559 | 2.9% |
| Other values (130) | 89947 |
| Value | Count | Frequency (%) |
| 1 | 790 | 0.1% |
| 2 | 12968 | 2.2% |
| 3 | 52369 | |
| 4 | 85122 | |
| 5 | 81039 | |
| 6 | 67578 | |
| 7 | 55528 | |
| 8 | 42693 | |
| 9 | 34109 | |
| 10 | 26935 | 4.6% |
| Value | Count | Frequency (%) |
| 160 | 1 | < 0.1% |
| 158 | 1 | < 0.1% |
| 156 | 2 | |
| 154 | 1 | < 0.1% |
| 149 | 1 | < 0.1% |
| 146 | 1 | < 0.1% |
| 144 | 1 | < 0.1% |
| 142 | 2 | |
| 141 | 2 | |
| 139 | 3 |
CRS_ARR_TIME
Real number (ℝ)
| Distinct | 1335 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1488.109 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 714 |
| Q1 | 1100 |
| median | 1518 |
| Q3 | 1930 |
| 95-th percentile | 2302 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 830 |
Descriptive statistics
| Standard deviation | 531.02286 |
|---|---|
| Coefficient of variation (CV) | 0.35684405 |
| Kurtosis | -0.45276381 |
| Mean | 1488.109 |
| Median Absolute Deviation (MAD) | 416 |
| Skewness | -0.31467084 |
| Sum | 8.635824 × 108 |
| Variance | 281985.27 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2359 | 3000 | 0.5% |
| 1640 | 1717 | 0.3% |
| 1810 | 1699 | 0.3% |
| 1900 | 1679 | 0.3% |
| 2355 | 1623 | 0.3% |
| 1915 | 1614 | 0.3% |
| 1845 | 1591 | 0.3% |
| 935 | 1583 | 0.3% |
| 930 | 1581 | 0.3% |
| 2120 | 1565 | 0.3% |
| Other values (1325) | 562670 |
| Value | Count | Frequency (%) |
| 1 | 87 | < 0.1% |
| 2 | 66 | < 0.1% |
| 3 | 113 | < 0.1% |
| 4 | 172 | < 0.1% |
| 5 | 736 | |
| 6 | 125 | < 0.1% |
| 7 | 139 | < 0.1% |
| 8 | 108 | < 0.1% |
| 9 | 107 | < 0.1% |
| 10 | 504 |
| Value | Count | Frequency (%) |
| 2359 | 3000 | |
| 2358 | 917 | 0.2% |
| 2357 | 933 | 0.2% |
| 2356 | 654 | 0.1% |
| 2355 | 1623 | |
| 2354 | 618 | 0.1% |
| 2353 | 357 | 0.1% |
| 2352 | 387 | 0.1% |
| 2351 | 391 | 0.1% |
| 2350 | 823 | 0.1% |
ARR_TIME
Real number (ℝ)
MISSING
| Distinct | 1440 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 7579 |
| Missing (%) | 1.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1456.8325 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 613 |
| Q1 | 1040 |
| median | 1502 |
| Q3 | 1922 |
| 95-th percentile | 2257 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 882 |
Descriptive statistics
| Standard deviation | 557.90234 |
|---|---|
| Coefficient of variation (CV) | 0.38295572 |
| Kurtosis | -0.35157085 |
| Mean | 1456.8325 |
| Median Absolute Deviation (MAD) | 440 |
| Skewness | -0.40488674 |
| Sum | 8.3439062 × 108 |
| Variance | 311255.02 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 946 | 635 | 0.1% |
| 1851 | 628 | 0.1% |
| 1640 | 622 | 0.1% |
| 2139 | 618 | 0.1% |
| 1114 | 617 | 0.1% |
| 937 | 617 | 0.1% |
| 1840 | 613 | 0.1% |
| 938 | 612 | 0.1% |
| 1620 | 612 | 0.1% |
| 1906 | 612 | 0.1% |
| Other values (1430) | 566557 | |
| (Missing) | 7579 | 1.3% |
| Value | Count | Frequency (%) |
| 1 | 467 | |
| 2 | 398 | |
| 3 | 375 | |
| 4 | 375 | |
| 5 | 368 | |
| 6 | 357 | |
| 7 | 369 | |
| 8 | 323 | |
| 9 | 315 | |
| 10 | 336 |
| Value | Count | Frequency (%) |
| 2400 | 367 | |
| 2359 | 417 | |
| 2358 | 405 | |
| 2357 | 450 | |
| 2356 | 409 | |
| 2355 | 467 | |
| 2354 | 443 | |
| 2353 | 456 | |
| 2352 | 483 | |
| 2351 | 469 |
ARR_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 1167 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 8789 |
| Missing (%) | 1.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.0699067 |
| Minimum | -80 |
|---|---|
| Maximum | 4405 |
| Zeros | 11025 |
| Zeros (%) | 1.9% |
| Negative | 321212 |
| Negative (%) | 55.4% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | -80 |
|---|---|
| 5-th percentile | -25 |
| Q1 | -13 |
| median | -3 |
| Q3 | 13 |
| 95-th percentile | 82 |
| Maximum | 4405 |
| Range | 4485 |
| Interquartile range (IQR) | 26 |
Descriptive statistics
| Standard deviation | 56.296564 |
|---|---|
| Coefficient of variation (CV) | 6.2069618 |
| Kurtosis | 288.93795 |
| Mean | 9.0699067 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 11.467622 |
| Sum | 5183751 |
| Variance | 3169.3031 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -9 | 15137 | 2.6% |
| -11 | 15136 | 2.6% |
| -10 | 14945 | 2.6% |
| -12 | 14800 | 2.6% |
| -8 | 14799 | 2.6% |
| -7 | 14519 | 2.5% |
| -6 | 14349 | 2.5% |
| -13 | 14170 | 2.4% |
| -14 | 13793 | 2.4% |
| -5 | 13525 | 2.3% |
| Other values (1157) | 426360 |
| Value | Count | Frequency (%) |
| -80 | 1 | < 0.1% |
| -78 | 1 | < 0.1% |
| -77 | 1 | < 0.1% |
| -75 | 1 | < 0.1% |
| -74 | 1 | < 0.1% |
| -73 | 2 | < 0.1% |
| -71 | 2 | < 0.1% |
| -69 | 2 | < 0.1% |
| -68 | 3 | |
| -67 | 5 |
| Value | Count | Frequency (%) |
| 4405 | 1 | |
| 3246 | 1 | |
| 2807 | 1 | |
| 2663 | 1 | |
| 2559 | 1 | |
| 2271 | 1 | |
| 2098 | 1 | |
| 2016 | 1 | |
| 2015 | 1 | |
| 1949 | 1 |
CANCELLED
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
| 0.0 | |
|---|---|
| 1.0 | 7406 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1740966 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 572916 | |
| 1.0 | 7406 | 1.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 572916 | |
| 1.0 | 7406 | 1.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1153238 | |
| . | 580322 | |
| 1 | 7406 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1740966 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1153238 | |
| . | 580322 | |
| 1 | 7406 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1740966 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1153238 | |
| . | 580322 | |
| 1 | 7406 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1740966 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1153238 | |
| . | 580322 | |
| 1 | 7406 | 0.4% |
CANCELLATION_CODE
Categorical
MISSING
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 572916 |
| Missing (%) | 98.7% |
| Memory size | 4.4 MiB |
| B | |
|---|---|
| A | |
| C | |
| D | 5 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 7406 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | B |
|---|---|
| 2nd row | B |
| 3rd row | B |
| 4th row | B |
| 5th row | B |
Common Values
| Value | Count | Frequency (%) |
| B | 4444 | 0.8% |
| A | 2444 | 0.4% |
| C | 513 | 0.1% |
| D | 5 | < 0.1% |
| (Missing) | 572916 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| b | 4444 | |
| a | 2444 | |
| c | 513 | 6.9% |
| d | 5 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 4444 | |
| A | 2444 | |
| C | 513 | 6.9% |
| D | 5 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7406 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| B | 4444 | |
| A | 2444 | |
| C | 513 | 6.9% |
| D | 5 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7406 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| B | 4444 | |
| A | 2444 | |
| C | 513 | 6.9% |
| D | 5 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7406 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| B | 4444 | |
| A | 2444 | |
| C | 513 | 6.9% |
| D | 5 | 0.1% |
DIVERTED
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
| 0.0 | |
|---|---|
| 1.0 | 1383 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1740966 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 578939 | |
| 1.0 | 1383 | 0.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 578939 | |
| 1.0 | 1383 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1159261 | |
| . | 580322 | |
| 1 | 1383 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1740966 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1159261 | |
| . | 580322 | |
| 1 | 1383 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1740966 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1159261 | |
| . | 580322 | |
| 1 | 1383 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1740966 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1159261 | |
| . | 580322 | |
| 1 | 1383 | 0.1% |
AIR_TIME
Real number (ℝ)
MISSING
| Distinct | 645 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 8789 |
| Missing (%) | 1.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 116.22568 |
| Minimum | 8 |
|---|---|
| Maximum | 724 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 8 |
|---|---|
| 5-th percentile | 36 |
| Q1 | 64 |
| median | 100 |
| Q3 | 146 |
| 95-th percentile | 269 |
| Maximum | 724 |
| Range | 716 |
| Interquartile range (IQR) | 82 |
Descriptive statistics
| Standard deviation | 72.047693 |
|---|---|
| Coefficient of variation (CV) | 0.61989479 |
| Kurtosis | 3.0451039 |
| Mean | 116.22568 |
| Median Absolute Deviation (MAD) | 40 |
| Skewness | 1.5007338 |
| Sum | 66426811 |
| Variance | 5190.87 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 58 | 4816 | 0.8% |
| 61 | 4787 | 0.8% |
| 62 | 4778 | 0.8% |
| 60 | 4688 | 0.8% |
| 59 | 4671 | 0.8% |
| 64 | 4657 | 0.8% |
| 57 | 4652 | 0.8% |
| 63 | 4602 | 0.8% |
| 45 | 4592 | 0.8% |
| 65 | 4542 | 0.8% |
| Other values (635) | 524748 | |
| (Missing) | 8789 | 1.5% |
| Value | Count | Frequency (%) |
| 8 | 5 | < 0.1% |
| 9 | 14 | < 0.1% |
| 10 | 19 | < 0.1% |
| 11 | 7 | < 0.1% |
| 12 | 3 | < 0.1% |
| 13 | 9 | < 0.1% |
| 14 | 16 | < 0.1% |
| 15 | 33 | < 0.1% |
| 16 | 59 | |
| 17 | 132 |
| Value | Count | Frequency (%) |
| 724 | 1 | |
| 701 | 1 | |
| 695 | 1 | |
| 692 | 1 | |
| 686 | 1 | |
| 684 | 2 | |
| 683 | 1 | |
| 676 | 1 | |
| 675 | 1 | |
| 674 | 2 |
CARRIER_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 889 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 444278 |
| Missing (%) | 76.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.428847 |
| Minimum | 0 |
|---|---|
| Maximum | 3957 |
| Zeros | 61079 |
| Zeros (%) | 10.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3 |
| Q3 | 21 |
| 95-th percentile | 91 |
| Maximum | 3957 |
| Range | 3957 |
| Interquartile range (IQR) | 21 |
Descriptive statistics
| Standard deviation | 71.493927 |
|---|---|
| Coefficient of variation (CV) | 3.1875882 |
| Kurtosis | 264.43183 |
| Mean | 22.428847 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 12.266369 |
| Sum | 3051310 |
| Variance | 5111.3816 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 61079 | 10.5% |
| 1 | 2596 | 0.4% |
| 2 | 2575 | 0.4% |
| 3 | 2461 | 0.4% |
| 6 | 2437 | 0.4% |
| 4 | 2372 | 0.4% |
| 5 | 2338 | 0.4% |
| 7 | 2337 | 0.4% |
| 15 | 2297 | 0.4% |
| 8 | 2195 | 0.4% |
| Other values (879) | 53357 | 9.2% |
| (Missing) | 444278 |
| Value | Count | Frequency (%) |
| 0 | 61079 | |
| 1 | 2596 | 0.4% |
| 2 | 2575 | 0.4% |
| 3 | 2461 | 0.4% |
| 4 | 2372 | 0.4% |
| 5 | 2338 | 0.4% |
| 6 | 2437 | 0.4% |
| 7 | 2337 | 0.4% |
| 8 | 2195 | 0.4% |
| 9 | 2017 | 0.3% |
| Value | Count | Frequency (%) |
| 3957 | 1 | |
| 3246 | 1 | |
| 2807 | 1 | |
| 2015 | 1 | |
| 1996 | 1 | |
| 1949 | 1 | |
| 1928 | 1 | |
| 1861 | 1 | |
| 1853 | 1 | |
| 1776 | 1 |
WEATHER_DELAY
Real number (ℝ)
MISSING SKEWED ZEROS
| Distinct | 444 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 444278 |
| Missing (%) | 76.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.0412146 |
| Minimum | 0 |
|---|---|
| Maximum | 1738 |
| Zeros | 129948 |
| Zeros (%) | 22.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1738 |
| Range | 1738 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 29.354942 |
|---|---|
| Coefficient of variation (CV) | 9.6523746 |
| Kurtosis | 729.03203 |
| Mean | 3.0412146 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 22.817578 |
| Sum | 413739 |
| Variance | 861.71265 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 129948 | 22.4% |
| 3 | 141 | < 0.1% |
| 6 | 141 | < 0.1% |
| 15 | 133 | < 0.1% |
| 8 | 131 | < 0.1% |
| 2 | 127 | < 0.1% |
| 4 | 124 | < 0.1% |
| 7 | 124 | < 0.1% |
| 9 | 121 | < 0.1% |
| 10 | 121 | < 0.1% |
| Other values (434) | 4933 | 0.9% |
| (Missing) | 444278 |
| Value | Count | Frequency (%) |
| 0 | 129948 | |
| 1 | 101 | < 0.1% |
| 2 | 127 | < 0.1% |
| 3 | 141 | < 0.1% |
| 4 | 124 | < 0.1% |
| 5 | 108 | < 0.1% |
| 6 | 141 | < 0.1% |
| 7 | 124 | < 0.1% |
| 8 | 131 | < 0.1% |
| 9 | 121 | < 0.1% |
| Value | Count | Frequency (%) |
| 1738 | 1 | |
| 1728 | 1 | |
| 1214 | 1 | |
| 1207 | 1 | |
| 1201 | 1 | |
| 1169 | 1 | |
| 1113 | 1 | |
| 1106 | 1 | |
| 1105 | 1 | |
| 1091 | 1 |
NAS_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 378 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 444278 |
| Missing (%) | 76.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.393351 |
| Minimum | 0 |
|---|---|
| Maximum | 1198 |
| Zeros | 66192 |
| Zeros (%) | 11.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 18 |
| 95-th percentile | 56 |
| Maximum | 1198 |
| Range | 1198 |
| Interquartile range (IQR) | 18 |
Descriptive statistics
| Standard deviation | 29.167101 |
|---|---|
| Coefficient of variation (CV) | 2.1777299 |
| Kurtosis | 197.742 |
| Mean | 13.393351 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 9.0962065 |
| Sum | 1822085 |
| Variance | 850.71977 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 66192 | 11.4% |
| 1 | 3528 | 0.6% |
| 15 | 2712 | 0.5% |
| 2 | 2592 | 0.4% |
| 16 | 2590 | 0.4% |
| 3 | 2415 | 0.4% |
| 17 | 2349 | 0.4% |
| 4 | 2328 | 0.4% |
| 5 | 2181 | 0.4% |
| 18 | 2084 | 0.4% |
| Other values (368) | 47073 | 8.1% |
| (Missing) | 444278 |
| Value | Count | Frequency (%) |
| 0 | 66192 | |
| 1 | 3528 | 0.6% |
| 2 | 2592 | 0.4% |
| 3 | 2415 | 0.4% |
| 4 | 2328 | 0.4% |
| 5 | 2181 | 0.4% |
| 6 | 1968 | 0.3% |
| 7 | 1986 | 0.3% |
| 8 | 1932 | 0.3% |
| 9 | 1683 | 0.3% |
| Value | Count | Frequency (%) |
| 1198 | 1 | |
| 1094 | 1 | |
| 1054 | 1 | |
| 1015 | 1 | |
| 995 | 1 | |
| 994 | 1 | |
| 979 | 1 | |
| 948 | 2 | |
| 924 | 1 | |
| 911 | 1 |
SECURITY_DELAY
Real number (ℝ)
MISSING SKEWED ZEROS
| Distinct | 96 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 444278 |
| Missing (%) | 76.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.13552968 |
| Minimum | 0 |
|---|---|
| Maximum | 376 |
| Zeros | 135274 |
| Zeros (%) | 23.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 376 |
| Range | 376 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.954861 |
|---|---|
| Coefficient of variation (CV) | 21.802316 |
| Kurtosis | 4812.3571 |
| Mean | 0.13552968 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 54.909417 |
| Sum | 18438 |
| Variance | 8.7312034 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 135274 | 23.3% |
| 15 | 39 | < 0.1% |
| 10 | 34 | < 0.1% |
| 7 | 32 | < 0.1% |
| 5 | 29 | < 0.1% |
| 17 | 29 | < 0.1% |
| 18 | 27 | < 0.1% |
| 16 | 25 | < 0.1% |
| 19 | 25 | < 0.1% |
| 6 | 24 | < 0.1% |
| Other values (86) | 506 | 0.1% |
| (Missing) | 444278 |
| Value | Count | Frequency (%) |
| 0 | 135274 | |
| 1 | 22 | < 0.1% |
| 2 | 24 | < 0.1% |
| 3 | 17 | < 0.1% |
| 4 | 17 | < 0.1% |
| 5 | 29 | < 0.1% |
| 6 | 24 | < 0.1% |
| 7 | 32 | < 0.1% |
| 8 | 24 | < 0.1% |
| 9 | 18 | < 0.1% |
| Value | Count | Frequency (%) |
| 376 | 1 | |
| 323 | 1 | |
| 301 | 1 | |
| 231 | 1 | |
| 201 | 1 | |
| 200 | 1 | |
| 157 | 1 | |
| 155 | 1 | |
| 152 | 1 | |
| 150 | 1 |
LATE_AIRCRAFT_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 660 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 444278 |
| Missing (%) | 76.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.472869 |
| Minimum | 0 |
|---|---|
| Maximum | 2530 |
| Zeros | 67326 |
| Zeros (%) | 11.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 30 |
| 95-th percentile | 111 |
| Maximum | 2530 |
| Range | 2530 |
| Interquartile range (IQR) | 30 |
Descriptive statistics
| Standard deviation | 57.694096 |
|---|---|
| Coefficient of variation (CV) | 2.2649234 |
| Kurtosis | 171.43697 |
| Mean | 25.472869 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 9.0226545 |
| Sum | 3465431 |
| Variance | 3328.6088 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 67326 | 11.6% |
| 15 | 1796 | 0.3% |
| 16 | 1724 | 0.3% |
| 17 | 1589 | 0.3% |
| 18 | 1518 | 0.3% |
| 19 | 1408 | 0.2% |
| 20 | 1373 | 0.2% |
| 21 | 1296 | 0.2% |
| 14 | 1266 | 0.2% |
| 13 | 1236 | 0.2% |
| Other values (650) | 55512 | 9.6% |
| (Missing) | 444278 |
| Value | Count | Frequency (%) |
| 0 | 67326 | |
| 1 | 850 | 0.1% |
| 2 | 965 | 0.2% |
| 3 | 866 | 0.1% |
| 4 | 952 | 0.2% |
| 5 | 962 | 0.2% |
| 6 | 1089 | 0.2% |
| 7 | 1060 | 0.2% |
| 8 | 1118 | 0.2% |
| 9 | 1071 | 0.2% |
| Value | Count | Frequency (%) |
| 2530 | 1 | |
| 2246 | 1 | |
| 2098 | 1 | |
| 1865 | 1 | |
| 1742 | 1 | |
| 1639 | 1 | |
| 1514 | 1 | |
| 1495 | 1 | |
| 1484 | 1 | |
| 1440 | 1 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 3/6/2023 12:00:00 AM | 9E | 4629 | 12953 | LGA | New York, NY | New York | 22 | 10577 | BGM | Binghamton, NY | New York | 22 | 2105 | 2100.0 | -5.0 | 15.0 | 5.0 | 2211 | 2152.0 | -19.0 | 0.0 | NaN | 0.0 | 32.0 | NaN | NaN | NaN | NaN | NaN |
| 1 | 1 | 3/6/2023 12:00:00 AM | 9E | 4630 | 11433 | DTW | Detroit, MI | Michigan | 43 | 11977 | GRB | Green Bay, WI | Wisconsin | 45 | 1000 | 956.0 | -4.0 | 9.0 | 2.0 | 1048 | 1006.0 | -42.0 | 0.0 | NaN | 0.0 | 59.0 | NaN | NaN | NaN | NaN | NaN |
| 2 | 1 | 3/6/2023 12:00:00 AM | 9E | 4630 | 11977 | GRB | Green Bay, WI | Wisconsin | 45 | 11433 | DTW | Detroit, MI | Michigan | 43 | 1133 | 1153.0 | 20.0 | 10.0 | 8.0 | 1352 | 1356.0 | 4.0 | 0.0 | NaN | 0.0 | 45.0 | NaN | NaN | NaN | NaN | NaN |
| 3 | 1 | 3/6/2023 12:00:00 AM | 9E | 4631 | 10397 | ATL | Atlanta, GA | Georgia | 34 | 11641 | FAY | Fayetteville, NC | North Carolina | 36 | 1355 | 1345.0 | -10.0 | 24.0 | 3.0 | 1514 | 1504.0 | -10.0 | 0.0 | NaN | 0.0 | 52.0 | NaN | NaN | NaN | NaN | NaN |
| 4 | 1 | 3/6/2023 12:00:00 AM | 9E | 4631 | 11641 | FAY | Fayetteville, NC | North Carolina | 36 | 10397 | ATL | Atlanta, GA | Georgia | 34 | 1600 | 1604.0 | 4.0 | 12.0 | 6.0 | 1739 | 1722.0 | -17.0 | 0.0 | NaN | 0.0 | 60.0 | NaN | NaN | NaN | NaN | NaN |
| 5 | 1 | 3/6/2023 12:00:00 AM | 9E | 4632 | 12478 | JFK | New York, NY | New York | 22 | 12397 | ITH | Ithaca/Cortland, NY | New York | 22 | 2200 | 2151.0 | -9.0 | 18.0 | 3.0 | 2312 | 2253.0 | -19.0 | 0.0 | NaN | 0.0 | 41.0 | NaN | NaN | NaN | NaN | NaN |
| 6 | 1 | 3/6/2023 12:00:00 AM | 9E | 4633 | 11042 | CLE | Cleveland, OH | Ohio | 44 | 12953 | LGA | New York, NY | New York | 22 | 1015 | 1010.0 | -5.0 | 24.0 | 7.0 | 1156 | 1141.0 | -15.0 | 0.0 | NaN | 0.0 | 60.0 | NaN | NaN | NaN | NaN | NaN |
| 7 | 1 | 3/6/2023 12:00:00 AM | 9E | 4633 | 12953 | LGA | New York, NY | New York | 22 | 11042 | CLE | Cleveland, OH | Ohio | 44 | 730 | 725.0 | -5.0 | 20.0 | 6.0 | 923 | 911.0 | -12.0 | 0.0 | NaN | 0.0 | 80.0 | NaN | NaN | NaN | NaN | NaN |
| 8 | 1 | 3/6/2023 12:00:00 AM | 9E | 4634 | 11193 | CVG | Cincinnati, OH | Kentucky | 52 | 11433 | DTW | Detroit, MI | Michigan | 43 | 620 | 610.0 | -10.0 | 11.0 | 6.0 | 741 | 706.0 | -35.0 | 0.0 | NaN | 0.0 | 39.0 | NaN | NaN | NaN | NaN | NaN |
| 9 | 1 | 3/6/2023 12:00:00 AM | 9E | 4635 | 10821 | BWI | Baltimore, MD | Maryland | 35 | 12478 | JFK | New York, NY | New York | 22 | 1702 | 1657.0 | -5.0 | 29.0 | 13.0 | 1845 | 1819.0 | -26.0 | 0.0 | NaN | 0.0 | 40.0 | NaN | NaN | NaN | NaN | NaN |
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 580312 | 7 | 3/26/2023 12:00:00 AM | YX | 5851 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 12339 | IND | Indianapolis, IN | Indiana | 42 | 920 | 933.0 | 13.0 | 23.0 | 6.0 | 1206 | 1225.0 | 19.0 | 0.0 | NaN | 0.0 | 143.0 | 0.0 | 0.0 | 19.0 | 0.0 | 0.0 |
| 580313 | 7 | 3/26/2023 12:00:00 AM | YX | 5852 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 14100 | PHL | Philadelphia, PA | Pennsylvania | 23 | 1945 | 1944.0 | -1.0 | 21.0 | 4.0 | 2124 | 2115.0 | -9.0 | 0.0 | NaN | 0.0 | 66.0 | NaN | NaN | NaN | NaN | NaN |
| 580314 | 7 | 3/26/2023 12:00:00 AM | YX | 5853 | 12478 | JFK | New York, NY | New York | 22 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 600 | 605.0 | 5.0 | 21.0 | 13.0 | 717 | 720.0 | 3.0 | 0.0 | NaN | 0.0 | 41.0 | NaN | NaN | NaN | NaN | NaN |
| 580315 | 7 | 3/26/2023 12:00:00 AM | YX | 5854 | 12953 | LGA | New York, NY | New York | 22 | 10693 | BNA | Nashville, TN | Tennessee | 54 | 1050 | 1046.0 | -4.0 | 12.0 | 9.0 | 1238 | 1226.0 | -12.0 | 0.0 | NaN | 0.0 | 139.0 | NaN | NaN | NaN | NaN | NaN |
| 580316 | 7 | 3/26/2023 12:00:00 AM | YX | 5856 | 14524 | RIC | Richmond, VA | Virginia | 38 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1240 | 1234.0 | -6.0 | 11.0 | 8.0 | 1422 | 1401.0 | -21.0 | 0.0 | NaN | 0.0 | 68.0 | NaN | NaN | NaN | NaN | NaN |
| 580317 | 7 | 3/26/2023 12:00:00 AM | YX | 5857 | 12339 | IND | Indianapolis, IN | Indiana | 42 | 12953 | LGA | New York, NY | New York | 22 | 1355 | 1353.0 | -2.0 | 21.0 | 17.0 | 1556 | 1557.0 | 1.0 | 0.0 | NaN | 0.0 | 86.0 | NaN | NaN | NaN | NaN | NaN |
| 580318 | 7 | 3/26/2023 12:00:00 AM | YX | 5858 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 11278 | DCA | Washington, DC | Virginia | 38 | 1220 | 1223.0 | 3.0 | 17.0 | 3.0 | 1408 | 1405.0 | -3.0 | 0.0 | NaN | 0.0 | 82.0 | NaN | NaN | NaN | NaN | NaN |
| 580319 | 7 | 3/26/2023 12:00:00 AM | YX | 5859 | 12953 | LGA | New York, NY | New York | 22 | 15016 | STL | St. Louis, MO | Missouri | 64 | 1429 | 1423.0 | -6.0 | 17.0 | 6.0 | 1626 | 1622.0 | -4.0 | 0.0 | NaN | 0.0 | 156.0 | NaN | NaN | NaN | NaN | NaN |
| 580320 | 7 | 3/26/2023 12:00:00 AM | YX | 5861 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 11278 | DCA | Washington, DC | Virginia | 38 | 1015 | 1317.0 | 182.0 | 19.0 | 5.0 | 1204 | 1500.0 | 176.0 | 0.0 | NaN | 0.0 | 79.0 | 176.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 580321 | 7 | 3/26/2023 12:00:00 AM | YX | 5862 | 12953 | LGA | New York, NY | New York | 22 | 14307 | PVD | Providence, RI | Rhode Island | 15 | 1600 | 1617.0 | 17.0 | 13.0 | 5.0 | 1708 | 1705.0 | -3.0 | 0.0 | NaN | 0.0 | 30.0 | NaN | NaN | NaN | NaN | NaN |